UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dCMO0T537pYFEuSxu7B/ugFXBAJkBGjsEHYBjTKXY18='
WHERE
key_id = 'd67e21e1e544650549de9c920bbf181e3eacd68058876a6609ebee2af3cdcc24'
AND (
token = 'dCMO0T537pYFEuSxu7B/ugFXBAJkBGjsEHYBjTKXY18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)