UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y0VYPHwot/77acvmdU7jf/MVS3lD7VVhO2OwMNjF7VA='
WHERE
key_id = '9cc6ad7b703452efff7d7d7bd35857294a24f31c8389113246331e9c5549b070'
AND (
token = 'y0VYPHwot/77acvmdU7jf/MVS3lD7VVhO2OwMNjF7VA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)