slow performance of mysql select distinct within IN query of large table for delete

slow performance of mysql select distinct within IN query of large table for delete
Apply only if you are expert in mysql/maria db

example-
DELETE FROM steercost WHERE steercost.ob_Subscriber_rid=13909213 AND steercost.ob_FeedTrack_RID IN('54662388','54662389','54662390','54662391','54662392') AND (steercost.LotSold<>1 OR steercost.LotSold IS NULL) ;