my $sql = sprintf q[
SELECT *
FROM my_table
WHERE 
   col_1 IN (%s) AND
   col_2 IN (%s)
], join(', ', @$set_1), join(', ', @$set_2);