Overturned lorry set to cause travel chaos near Rotherham