The UPDATE statement does not have any effect if the statement does not actually change any column values, even there is a TIMESTAMP column with ON UPDATE CURRENT_TIMESTAMP.

You can use ORDER BY and LIMIT in the UPDATE statement.

The --safe-updates option is for preventing dangerous UPDATE statement, such as no WHERE clause.