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