UPDATE wp_posts
SET post_content = REPLACE(post_content, 'https:', 'http:')
WHERE post_content like '%https:%';

UPDATE wp_posts
SET post_title = REPLACE(post_title, 'https:', 'http:')
WHERE post_title like '%https:%';