UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7JTGN1D5aLKaVPaxneCSROHGi6fZM8ETSvoOqQ8mO8Y='
WHERE
key_id = 'cd00a29fa55aa2cd7b4e83e3f97cde703c209cfc3df0800f351eebb9b2cf528d'
AND (
token = '7JTGN1D5aLKaVPaxneCSROHGi6fZM8ETSvoOqQ8mO8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)