UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'my8Z1SI8R6ICRq8vz1DGfuxb06gt4VYbhzP82paBYFw='
WHERE
key_id = '3704aeef2fc07820d35890b0330a536197d965f39266001cdb1481f13e57e99e'
AND (
token = 'my8Z1SI8R6ICRq8vz1DGfuxb06gt4VYbhzP82paBYFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)