UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cmH/tKmxkNzRf+VXjdN989thrBxAAhsfRa0VBJvXCGU='
WHERE
key_id = 'bbdb6d64adae5a3e202cf9bcddb3ade4320beab145e3a51b45f39e8d5d5f07a7'
AND (
token = 'cmH/tKmxkNzRf+VXjdN989thrBxAAhsfRa0VBJvXCGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)