Use a JOIN when updating trough an association with default ordering on mysql.

The ordering can be ignored unless a LIMIT or an OFFSET is also present.