Unique key and LIMIT 1

Any lookup involving a unique key will just return the one row regardless of whether or not you specify LIMIT 1

Leaving off the LIMIT 1 will make the code more portable as that is a mySQL only instruction.