UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JkcETKpSYt7Xti58/QXO3qzqm8SuH3PylV9lMzrIBZQ='
WHERE
key_id = 'fb1dc7d54e7c84271b08167bef7eac3c431a4a232a57b7b073d85baa7997f79b'
AND (
token = 'JkcETKpSYt7Xti58/QXO3qzqm8SuH3PylV9lMzrIBZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)