UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M5e06DspvkMm3/cUJ2iVAcMXyhipF7iXrs0S0PtCmfI='
WHERE
key_id = '2c4356100f45ba097f7aea67b75cea9bad8beedf2276e0999e0ff21a40b59628'
AND (
token = 'M5e06DspvkMm3/cUJ2iVAcMXyhipF7iXrs0S0PtCmfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)