UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0X7IxHE8vvg0iL++ypR/Ut3P51eoRiuOpauNI6neT00='
WHERE
key_id = 'bdc293919193cc8fd835f0ead78b4ca98ff51f0182d7c88d4a042fc4d83dfd65'
AND (
token = '0X7IxHE8vvg0iL++ypR/Ut3P51eoRiuOpauNI6neT00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)