UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQKepBdzMh8Ut4jgItQ3Xwd2h/5a0vumRDktuG9V8QA='
WHERE
key_id = 'c19a2b925e0a61c7260f0a00169c49a070561698628a9a6b478887a0c4968c10'
AND (
token = 'zQKepBdzMh8Ut4jgItQ3Xwd2h/5a0vumRDktuG9V8QA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)