UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KX7JaVJ3fAlhmIdzgI1t5bMeV3ebXHbz8UIkOoVr9x4='
WHERE
key_id = '1e3a21f0eafc06d726c05a1252eb3f67a6e795284ef48622968ca64de3e69038'
AND (
token = 'KX7JaVJ3fAlhmIdzgI1t5bMeV3ebXHbz8UIkOoVr9x4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)