UPDATE wp_posts SET comment_status = 'closed'
WHERE comment_status = 'open' AND post_type = 'attachment'