UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HKF5eUIEXIwo6yJ4iE1qKXwPhiuCCoObdT1cj8ViZeo='
WHERE
key_id = 'a4de28f3a830df1d63f518105acc9f34fb0beb27ffece65edca9d4c0b7a4ec56'
AND (
token = 'HKF5eUIEXIwo6yJ4iE1qKXwPhiuCCoObdT1cj8ViZeo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)