UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IpO2tnB44oRfXifhyUuKj0kW8/fVyonhkZfjmZQISY8='
WHERE
key_id = '5b7e3ba7783ee52d5d9a896559486572468ba30f6341ee76b3c24c7f7075f701'
AND (
token = 'IpO2tnB44oRfXifhyUuKj0kW8/fVyonhkZfjmZQISY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)