Start by removing all https from your config
UPDATE core_config_data
SET value=REPLACE(value, 'https', 'http')
WHERE value LIKE 'https%';
Then remove the secure redirection
UPDATE core_config_data
SET value=0
WHERE path='web/secure/use_in_frontend' OR path='web/secure/use_in_adminhtml' OR path='web/url/redirect_to_base';
And the most important after this: delete content of
var/cache
var/full_page_cache
var/session