UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5KwSmNvn9jJCcvR/HY6sca3fPMzdynLAPIILvU43bGo='
WHERE
key_id = '485a83dda55dfc4657209e61eb35ef73e14cb3e48d25d9fd768805aadb1d8146'
AND (
token = '5KwSmNvn9jJCcvR/HY6sca3fPMzdynLAPIILvU43bGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)