The difference between the locking tuners and non-locking tuners is that locking tuners have a clamping mechanism to lock the string in place.

Locking tuners are most beneficial for guitars with a tremolo, as the strings are locked to the tuner. This reduces the amount of string slippage and will better keep the guitar in tune when using a tremolo.