mysql update with sum in same table for rows with same values code example

Example: mysql update sum same table

UPDATE products SET quantity = quantity + 10 WHERE id = 8