UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C1qj9M68vW/tS2nnENgCrW4sePIMGiCLJcxLX3LvIOw='
WHERE
key_id = '0cc65040a1f045a7a73f97fd45bf1247565d2447c46959c96690384f6148724e'
AND (
token = 'C1qj9M68vW/tS2nnENgCrW4sePIMGiCLJcxLX3LvIOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)