How cold does it have to be for water to instantly freeze?

It depends on concentration of salt. Adding four tablespoons of salt to a mix of 1 liter of water and a tray of icecubes will thaw the ice while dropping temperature of the mix down to 14 degrees centigrade below zero.