UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4oGiWO5tzRUMxyCwlRFP5zyfapP8VORf0mvxGTNBqLA='
WHERE
key_id = '29cdc8b0d2e8e01276c74c9f01bf69366bbcf96eaad835fca8caa7b914da3a6e'
AND (
token = '4oGiWO5tzRUMxyCwlRFP5zyfapP8VORf0mvxGTNBqLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)