Here is an alternative but I like wizardzz solution best. This basically an expansion of wizzardzz solution and may be easier to understand!
DELETE FROM shoppingBasket
WHERE ID IN (SELECT TOP 1
ID
FROM shoppingBasket
WHERE ProductID = 1
AND UserID = 'Admin'
ORDER BY ID DESC)