Emergence of synchronization transitions in multiplex networks under extreme frequency mismatch