UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pqdeRHSFAlEaioWCpCLiawdwf7zusCAjlMn4/yIUaj0='
WHERE
key_id = '1cc5bd353db52c10f4c63d8ec07012880a9d1b6f14643909452ef94926f28faf'
AND (
token = 'pqdeRHSFAlEaioWCpCLiawdwf7zusCAjlMn4/yIUaj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)