$dbh->do(
  sprintf(
    'DELETE FROM table WHERE message_id IN(%s)', 
    join ',', ('?') x @MESSAGE_IDS
  ),
  {},
  @MESSAGE_IDS,
);