Standoff between assailant and police negotiators at a supermarket lasted around 40 minutes, after which he was killed by police