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