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