@Obito and by what script - BR, catalog client script (calling Ajax), scheduled job, flow, .... ? 

Not knowing your conditions, to delete it always or under conditions, for all user or just some...?

Then you can write your code accordingly pointing to the table I shared [sc_cart_item].