UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZxPPJigOcSPCljfDf+A/2ttxlpyxNo8efO3g+//g38='
WHERE
key_id = '212ef89664439747c50913765c7940ae28ded2c2f90793bd3284c58f0db1a845'
AND (
token = 'XZxPPJigOcSPCljfDf+A/2ttxlpyxNo8efO3g+//g38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)