UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k7VesF1WDwckxu2P1HzcpLXzuWYgcacIknWfhF4THqc='
WHERE
key_id = '3f6064f36b6f7b4883e97904442e4529b2b4b19facafedf0fb97ad7e8d1b8b0e'
AND (
token = 'k7VesF1WDwckxu2P1HzcpLXzuWYgcacIknWfhF4THqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)