Shocking CCTV footage shows moment bungling burglar almost blew himself up