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