UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FZ4q8X09yzrkx/fLebPI5cy7ANcNZPNu6goalqCmZqw='
WHERE
key_id = 'ffa17629a3732e56e70ded6df62acb75af72e55f7f15516c8883d8d09739fd21'
AND (
token = 'FZ4q8X09yzrkx/fLebPI5cy7ANcNZPNu6goalqCmZqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)