UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ZpLNfpGmf7tYY7PwcTmS/Jg+TiYvDUEPbbguj1bkJY='
WHERE
key_id = '09833b578f54ddaefa7ff2f22a5cdf87b060d35d00b99859a5ebf1ccfb15c5ec'
AND (
token = '5ZpLNfpGmf7tYY7PwcTmS/Jg+TiYvDUEPbbguj1bkJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)