Create a unique index on the URL column, and use INSERT IGNORE when inserting data

I think this is probably the best solution. It doesn't matter who submits a URL, the date or anything else. A URL should be submitted once and if accepted, any future duplicate submissions should just be blocked altogether.