UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cMF1rjaavyIYJ6ao+eMScp46qwj13roOaXceuGFfiig='
WHERE
key_id = 'af2eaf5a7f5a45174b3059aac26d0ead17b1daffc431a0de9741a9cff7baae99'
AND (
token = 'cMF1rjaavyIYJ6ao+eMScp46qwj13roOaXceuGFfiig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)