The Met Office has issued 42 areas with a fresh yellow weather warning as frequent lightning and heavy downpours of rain is expected to continue following the heatwave