UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LnEoFgUYyPzzFSaJ9uDyAgyJyR4isZQH9y3+YuAVieU='
WHERE
key_id = '8e6f0b2ba3751912a638c66e856fe38a01c493a2cc12a2d488f701ab0b1ad6a9'
AND (
token = 'LnEoFgUYyPzzFSaJ9uDyAgyJyR4isZQH9y3+YuAVieU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)