UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UtFjhZNzb7bEYSJbDtKAEsLWZjEkNxUZW0RJrkiLG6c='
WHERE
key_id = '002a6a830b7a47f86130875f4cf74c9be88a2c372af44ee10a9a0e7aafef863f'
AND (
token = 'UtFjhZNzb7bEYSJbDtKAEsLWZjEkNxUZW0RJrkiLG6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)