UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9vyI0eW2TzHIhOx1weroEjnM1KVJgbVR8V1pCGnL2V0='
WHERE
key_id = '65de63c48a81e77f52d279ce923f0a9b22912f3e555106b82388e2b43c497d7f'
AND (
token = '9vyI0eW2TzHIhOx1weroEjnM1KVJgbVR8V1pCGnL2V0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)