Problem: Concurrent calls to GET_LOCK could cause deadlock, even with
a wait time of 0.

Root cause was that MDL_context::acquire_lock() would add the ticket
as waiter and perform deadlock detection analysis even when the wait
time was 0.

Solution: Return error immediately if lock cannot be obtained and wait
time is 0.

(cherry picked from commit c528fee7d9c8186bcc14549f62b1f835ab01c0c5)