A rare red warning for extreme heat is in effect as soaring temperatures continue