UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cr9iJi/BKjxFfn/OadmF5GV2p01qQcV2ScRdyG+V5S8='
WHERE
key_id = 'b7980b2f31dd285f58cc997d7714a9f86784bdd55060e117dca169153d80e64c'
AND (
token = 'cr9iJi/BKjxFfn/OadmF5GV2p01qQcV2ScRdyG+V5S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)