UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsHM3vZGhhfGNXxzBOyYGp5WJgX/Wmg37AJvJV+itFY='
WHERE
key_id = 'd1c2d506297362a99727cf2105c4cd31e62b27b64fb78d62bfa1cde581ca61b6'
AND (
token = 'ZsHM3vZGhhfGNXxzBOyYGp5WJgX/Wmg37AJvJV+itFY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)