SQL help INSERT/UPDATE/REPLACE

[Meestor_X]

Whoops! Should have been ASC, not DESC to replace the OLDEST record first…

@Meestor_X

UPDATE myTable
SET date=NOW()
WHERE (DATEDIFF(NOW(), date) > 30 AND userid = "$userid")
ORDER BY date ASC 
LIMIT 1;