UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sYOqdPttvcwrW1ah/c+jy1yRqt4ncldeIEwdAzf5aL8='
WHERE
key_id = 'c35db8d0af08792c2ea4e9bfa859658b7603be6d24d464c964e296df15519998'
AND (
token = 'sYOqdPttvcwrW1ah/c+jy1yRqt4ncldeIEwdAzf5aL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)