UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzuD7i6FEbMzxdSjfdQ9jCUkconez9NbX6u5BBBGfCM='
WHERE
key_id = '34799369abe7a7dda92e7195b177feb3a50ea8960d7d56f7342f0db9d5173168'
AND (
token = 'mzuD7i6FEbMzxdSjfdQ9jCUkconez9NbX6u5BBBGfCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)