UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S+7VqWbePfmMWkEYAxE6pAvpi/kos+33X8zI3d5lsv8='
WHERE
key_id = '6f83b20f40dc61aef42ca13aebfa70ba26aa42b003f48bd076fd95fb2d4af4eb'
AND (
token = 'S+7VqWbePfmMWkEYAxE6pAvpi/kos+33X8zI3d5lsv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)