delete FROM `order_surcharges` WHERE payment_id is NULL;
update `order_surcharges` set payment_id = NULL;
DELETE c1 FROM order_surcharges c1
INNER JOIN order_surcharges c2
WHERE
c1.id > c2.id AND
c1.delivery_id = c2.delivery_id AND
c1.threshold = c2.threshold
;