UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OFF9gpxIp78hF2HnsoKCJdnrOpM9H+xp1kmmeg0Brr0='
WHERE
key_id = '9b364dd4b714aea0871f30c26d667baf744ef8e742ec6e34d245955a62d299f0'
AND (
token = 'OFF9gpxIp78hF2HnsoKCJdnrOpM9H+xp1kmmeg0Brr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)