UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JtF5U5dqF6KqUhK4yHL8mdcTUYLY42BwujF9jvuAxH8='
WHERE
key_id = '1e811bafe689ac3091f30dda0a5d7b16d663df3ad6f7288eeb9d52f17ee77662'
AND (
token = 'JtF5U5dqF6KqUhK4yHL8mdcTUYLY42BwujF9jvuAxH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)