but even with no indexes it shouldnt have a problem with an SQL statement like this

SELECT codeID, code FROM zen_codes WHERE productID = 'c12s1d2s' AND viewed = 0 LIMIT 1

(c12s1d2s is a dummy productID)