UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Omc1sXOASNWrh1wvaT5iSFchq5KL0meiooQFjsHn2VU='
WHERE
key_id = '40a1ebe5dcf0293e6a1feeefef4ca06ecee26665fb5b128241b617da61735d99'
AND (
token = 'Omc1sXOASNWrh1wvaT5iSFchq5KL0meiooQFjsHn2VU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)